package com.hmall.mapper;

import com.hmall.model.MallProductStock;
import com.hmall.util.MyMapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.math.BigDecimal;
import java.util.List;

@Repository
public interface MallProductStockMapper extends MyMapper<MallProductStock> {

    MallProductStock selectByModelAndTwising(@Param("model") String s, @Param("twisting") String s1, @Param("grade") String grade);

    int selectAllCount(@Param("materialCode") String materialCode);

    List<MallProductStock> selectByLimit(@Param("materialCode") String materialCode, @Param("start") int start, @Param("end") int end);

    List<String> selectMaterialModelByList(@Param("materialCode") String materialCode, @Param("num") int i);
}